﻿<html lang="zh">
<head><title>fire数据库文档</title>
    <style type='text/css'>body {
        padding-bottom: 50px
    }

    body, td {
        font-family: verdana, fantasy;
        font-size: 12px;
        line-height: 150%
    }

    table {
        width: 100%;
        background-color: #ccc;
        margin: 5px 0
    }

    td {
        background-color: #fff;
        padding: 3px 3px 3px 10px
    }

    thead td {
        text-align: center;
        font-weight: bold;
        background-color: #eee
    }

    a:link, a:visited, a:active {
        color: #015fb6;
        text-decoration: none
    }

    a:hover {
        color: #e33e06
    }</style>
</head>
<body style='text-align:center;'>
<div style='width:800px; margin:20px auto; text-align:left;'><a name='index'></a>
    <h2 style='text-align:center; line-height:50px;'>fire数据库文档</h2>
    <div><b>数据库名：mall_order</b><br><b>文档版本：0.0.1-SNAPSHOT</b><br><b>文档描述：数据库文档生成</b><br></div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>表名</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td><a href='#mtl_salesout_all'>mtl_salesout_all</a></td>
            <td>2C汇总出库单表</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td><a href='#mtl_salesout_lines'>mtl_salesout_lines</a></td>
            <td>出库单汇总明细表</td>
        </tr>
    </table>
    <a name='mtl_salesout_all'></a>
    <div style='margin-top:30px;'><a href='#index'
                                     style='float:right; margin-top:6px;'>返回目录</a><b>表名：mtl_salesout_all</b></div>
    <div>说明：2C汇总出库单表</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>id</td>
            <td align='center'>bigint</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>id</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>salesout_no</td>
            <td align='center'>varchar</td>
            <td align='center'>100</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>出库单号</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>salesout_id</td>
            <td align='center'>varchar</td>
            <td align='center'>100</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>NC单据Id</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>tran_type</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>类型0出1入2运费</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>platform_code</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>平台编码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>platform_name</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>平台名称</td>
        </tr>
        <tr>
            <td style='text-align:center;'>7</td>
            <td>customer_no</td>
            <td align='center'>varchar</td>
            <td align='center'>100</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>NC客户</td>
        </tr>
        <tr>
            <td style='text-align:center;'>8</td>
            <td>customer_name</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>NC客户名称</td>
        </tr>
        <tr>
            <td style='text-align:center;'>9</td>
            <td>bill_date</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>单据日期</td>
        </tr>
        <tr>
            <td style='text-align:center;'>10</td>
            <td>ou_id</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>事业部编码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>11</td>
            <td>sales_org_no</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>销售组织</td>
        </tr>
        <tr>
            <td style='text-align:center;'>12</td>
            <td>inventory_org_no</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>库存组织</td>
        </tr>
        <tr>
            <td style='text-align:center;'>13</td>
            <td>extended_amount</td>
            <td align='center'>decimal</td>
            <td align='center'>24</td>
            <td align='center'>2</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>总金额（折后含税）</td>
        </tr>
        <tr>
            <td style='text-align:center;'>14</td>
            <td>discount_amount</td>
            <td align='center'>decimal</td>
            <td align='center'>24</td>
            <td align='center'>2</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>折扣金额（整单）</td>
        </tr>
        <tr>
            <td style='text-align:center;'>15</td>
            <td>note</td>
            <td align='center'>varchar</td>
            <td align='center'>500</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>备注</td>
        </tr>
        <tr>
            <td style='text-align:center;'>16</td>
            <td>syn_status</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>推送标志,0未1成功2失败</td>
        </tr>
        <tr>
            <td style='text-align:center;'>17</td>
            <td>syn_msg</td>
            <td align='center'>varchar</td>
            <td align='center'>1000</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>推送失败消息</td>
        </tr>
        <tr>
            <td style='text-align:center;'>18</td>
            <td>syn_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>推送时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>19</td>
            <td>created_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>创建时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>20</td>
            <td>updated_time</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>更新时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>21</td>
            <td>created_by</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>创建人</td>
        </tr>
        <tr>
            <td style='text-align:center;'>22</td>
            <td>updated_by</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>更新人</td>
        </tr>
        <tr>
            <td style='text-align:center;'>23</td>
            <td>revision</td>
            <td align='center'>bigint</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>版本号</td>
        </tr>
    </table>
    <a name='mtl_salesout_lines'></a>
    <div style='margin-top:30px;'><a href='#index'
                                     style='float:right; margin-top:6px;'>返回目录</a><b>表名：mtl_salesout_lines</b></div>
    <div>说明：出库单汇总明细表</div>
    <div>数据列：</div>
    <table cellspacing='1'>
        <thead>
        <tr>
            <td style='width:40px; '>序号</td>
            <td>名称</td>
            <td>数据类型</td>
            <td>长度</td>
            <td>小数位</td>
            <td>允许空值</td>
            <td>主键</td>
            <td>默认值</td>
            <td>说明</td>
        </tr>
        </thead>
        <tr>
            <td style='text-align:center;'>1</td>
            <td>id</td>
            <td align='center'>bigint</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>N</td>
            <td align='center'>Y</td>
            <td align='center'></td>
            <td align='center'>id</td>
        </tr>
        <tr>
            <td style='text-align:center;'>2</td>
            <td>salesout_no</td>
            <td align='center'>bigint</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>出库单号</td>
        </tr>
        <tr>
            <td style='text-align:center;'>3</td>
            <td>warehouse_no</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>发货仓代码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>4</td>
            <td>sales_org_no</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>销售组织</td>
        </tr>
        <tr>
            <td style='text-align:center;'>5</td>
            <td>inventory_org_no</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>库存组织</td>
        </tr>
        <tr>
            <td style='text-align:center;'>6</td>
            <td>channel_code</td>
            <td align='center'>varchar</td>
            <td align='center'>255</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>渠道编码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>7</td>
            <td>extended_amount</td>
            <td align='center'>decimal</td>
            <td align='center'>20</td>
            <td align='center'>4</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>总金额（折后未税）</td>
        </tr>
        <tr>
            <td style='text-align:center;'>8</td>
            <td>gross_extended_amount</td>
            <td align='center'>decimal</td>
            <td align='center'>20</td>
            <td align='center'>4</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>总金额（折后含税）</td>
        </tr>
        <tr>
            <td style='text-align:center;'>9</td>
            <td>bill_date</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>单据日期</td>
        </tr>
        <tr>
            <td style='text-align:center;'>10</td>
            <td>free_goods_flag</td>
            <td align='center'>tinyint</td>
            <td align='center'>3</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>是否是赠品</td>
        </tr>
        <tr>
            <td style='text-align:center;'>11</td>
            <td>unit_selling_price</td>
            <td align='center'>decimal</td>
            <td align='center'>20</td>
            <td align='center'>4</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>含税单价</td>
        </tr>
        <tr>
            <td style='text-align:center;'>12</td>
            <td>gross_unit_selling_price</td>
            <td align='center'>decimal</td>
            <td align='center'>20</td>
            <td align='center'>4</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>含税单价</td>
        </tr>
        <tr>
            <td style='text-align:center;'>13</td>
            <td>tax_rate</td>
            <td align='center'>decimal</td>
            <td align='center'>20</td>
            <td align='center'>4</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>税率</td>
        </tr>
        <tr>
            <td style='text-align:center;'>14</td>
            <td>num</td>
            <td align='center'>int</td>
            <td align='center'>10</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>数量</td>
        </tr>
        <tr>
            <td style='text-align:center;'>15</td>
            <td>inventory_item_no</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>物料编码</td>
        </tr>
        <tr>
            <td style='text-align:center;'>16</td>
            <td>inventory_item_name</td>
            <td align='center'>varchar</td>
            <td align='center'>100</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>物料名称</td>
        </tr>
        <tr>
            <td style='text-align:center;'>17</td>
            <td>product_line_no</td>
            <td align='center'>varchar</td>
            <td align='center'>50</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品线</td>
        </tr>
        <tr>
            <td style='text-align:center;'>18</td>
            <td>product_line_name</td>
            <td align='center'>varchar</td>
            <td align='center'>100</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>产品线</td>
        </tr>
        <tr>
            <td style='text-align:center;'>19</td>
            <td>creation_date</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>创建时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>20</td>
            <td>last_update_date</td>
            <td align='center'>datetime</td>
            <td align='center'>19</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>修改时间</td>
        </tr>
        <tr>
            <td style='text-align:center;'>21</td>
            <td>order_source</td>
            <td align='center'>varchar</td>
            <td align='center'>100</td>
            <td align='center'>0</td>
            <td align='center'>Y</td>
            <td align='center'>N</td>
            <td align='center'></td>
            <td align='center'>数据来源</td>
        </tr>
    </table>
</div>
<footer></footer>
</body>
</html>